[dbo].[asi_GroupActiveMembershipCount]

SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_GroupActiveMembershipCount

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@groupkey	uniqueidentifier	16

SQL Script

CREATE PROCEDURE [dbo].[asi_GroupActiveMembershipCount]
    @groupkey uniqueidentifier
    AS
BEGIN
    SELECT COUNT(1) AS MemberCount
    FROM GroupMember
    WHERE GroupKey=@groupkey AND IsActive=1
END

GO

Uses

[dbo].[GroupMember]
dbo